Processing data updates within a data maintenance system

ABSTRACT

Maintaining data in a data management system including at least one processor and a storage system includes accessing a first data source providing one or more source elements of data; accessing a storage system storing one or more subsets of data, each subset including at least one element of data, and storing one or more descriptors identifying a data source for a subset and identifying a data source for each of one or more elements of the subset; and processing rules that determine if, according to the descriptors, an element in the storage system is allowed to be changed.

CROSS-REFERENCE TO RELATED APPLICATIONS

This application claims priority to U.S. Application Ser. No.61/119,148, filed on Dec. 2, 2008, incorporated herein by reference.

BACKGROUND

This description relates to a data maintenance system.

A modern data maintenance system may receive data from multiple sources.Rather than serve as a simple passive storage mechanism, a datamaintenance system may be required to maintain a consolidated repositoryfor the data from the multiple sources, and provide to users of thesystem a unified view of and single point of access for the entirety ofthe data. However, consolidating multiple sources of data presentsseveral challenges. Different sources may each contain segments of alogical data collection such as a database, or they may each containdifferent temporal versions of the same data, such as newly-updated dataor outdated data. These sources may all store data in an arrangement orformat different from the arrangement or format of the data storagesystem.

SUMMARY

In a general aspect, a method for maintaining data in a data managementsystem including at least one processor and a storage system includesaccessing a first data source providing one or more source elements ofdata; accessing a storage system storing one or more subsets of data,each subset including at least one element of data, and storing one ormore descriptors identifying a data source for a subset and identifyinga data source for each of one or more elements of the subset; andprocessing rules that determine if, according to the descriptors, anelement in the storage system is allowed to be changed.

In another general aspect, a system for maintaining data includes astorage system storing one or more subsets of data, each subsetincluding at least one element of data, and one or more descriptors,each identifying a data source for a subset and identifying a datasource for each of one or more elements of the subset; a first datasource providing one or more source elements of data; a data managerconfigured to process rules that determine if, according to thedescriptors, an element in the storage system is allowed to be changed.

In another general aspect, a system for maintaining data in a datamanagement system includes means for accessing a first data sourceproviding one or more source elements of data; means for accessing astorage system storing one or more subsets of data, each subsetincluding at least one element of data, and storing one or moredescriptors identifying a data source for a subset and identifying adata source for each element of the subset; and means for processingrules that determine if, according to the descriptors, an element in thestorage system is allowed to be changed.

In another general aspect, a computer program for maintaining data in adata management system, stored on a computer-readable medium, includesinstructions for causing a computer to access a first data sourceproviding one or more source elements of data; access a storage systemstoring one or more subsets of data, each subset including at least oneelement of data, and storing one or more descriptors identifying a datasource for a subset and identifying a data source for each element ofthe subset; and process rules that determine if, according to thedescriptors, an element in the storage system is allowed to be changed.

Aspects can include one or more of the following features.

At least one rule determines if, according to at least one descriptor,any of the source elements is to be used to replace an element in thestorage system.

At least one rule determines if, according to at least one descriptor,an element in the storage system is to be deleted in response to acorresponding source element being deleted.

A second data source is accessed, providing one or more source elementsof data different from the source elements provided by the first datasource.

The first data source is the data source for the subset and the seconddata source is the data source for at least one of the elements of thesubset.

At least one of the descriptors identifies a data source for a subsetand at least one other descriptor identifies another data source for anelement of the subset.

At least one of the rules requires user input.

At least one of the rules is handled automatically, without user input.

A maintenance plan is accessed containing the rules.

The maintenance plan includes a mapping indicating which source elementscorrespond to which elements in the storage system.

The first data source includes a user interface accepting direct userinput.

The data includes records that each store data elements in multiplefields.

A descriptor identifies a record owner that controls changes to a givenrecord.

The record owner controls deletion of the given record.

The record owner created the given record.

A descriptor identifies a field owner that controls changes to a dataelement stored in a given field of a given record.

The field owner controls updates to the data element stored in the givenfield.

A user interface is provided to a user and accepts decisions from theuser that relate to the storage system data elements.

Aspects of the invention can include one or more of the followingadvantages.

A data maintenance system is able to handle multiple data sources, whichpotentially overlap in terms of the data they contribute to a unifieddata collection, and which potentially are diverse in structure. Thedata maintenance system is able to keep track of the sources thatcontribute to an element in the system. The system is able to managedifferent sources, which may contribute different versions of theelement over time, and the system is able to make a determination as towhich source contents should be used to modify the version of theelement in the storage system. Further, if an element has been deletedfrom its authoritative source, the system is able to determine that thisdeletion represents a substantive change in the data.

Other features and advantages of the invention will become apparent fromthe following description, and from the claims.

DESCRIPTION OF DRAWINGS

FIG. 1 is an overview of a data maintenance system.

FIG. 2 is a diagram of some of the contents of a data destination.

FIG. 3 is a diagram of the components involved in processing data.

FIG. 4 is another diagram of the components involved in processing data.

FIG. 5 is a diagram of a system for creating a data maintenance plan.

FIG. 6A is a flowchart of operation for a data manager.

FIG. 6B is a flowchart of operation for a portion of a data manager.

FIG. 6C is a flowchart of operation for another portion of a datamanager.

DESCRIPTION 1 Overview

FIG. 1 is a block diagram of an exemplary data maintenance system 10showing the interrelationship between elements of the system 10. A datamanager 100 accepts multiple inputs for the purpose of providing data tobe loaded into a data destination 120. For example, the data maintenancesystem can be used for implementing a repository for metadata that isused by a data processing system to describe various data processingprograms, various sources of data, and various results of processing thedata from the sources using the programs. In that case, the datamaintenance system is able to extract information from various sourcesto form the metadata and to maintain a unified view of the dataprocessing system and its history of processing various kinds ofoperational data.

One input to the data manager 100 arrives by way of an extractor 102,which is capable of acquiring data 132 from one or more data sources130, 130 a, 130 b. The extractor provides one or more such sources tothe manager 100.

Another input is a data maintenance plan 110. Generally, each datasource 130 has a corresponding maintenance plan, which may be unique tothat particular source, or shared among several sources. The planincludes a mapping 112 of source data elements to destination dataelements. Further, the plan includes transformation rules 114,validation rules 116, and disposition rules 118 for handling differentaspects of processing the data. The rules address situations that canarise during the processing of a particular source, such as theformatting of an element value in the source, the addition of an elementto a source, and the removal of an element from a source. Further, therules also allow or deny modification of an element in the datadestination, depending on the source of that modification. Multiplemaintenance plans 110 a, 110 b, 110 c are placed in persistent storage150 for multiple uses over time.

Another input arrives by way of a user interface 140. In somesituations, the manager 100 functions autonomously and requires no userinterface input. In other situations, a user 142 initiates manageraction, for example, by clicking a button. In some situations, themanager 100 may also require user input to proceed beyond adecision-making point, or may have information to provide to a user. Inthese various cases, the user interface 140 acts as a conduit betweenthe user 142 and the manager 100.

Another input comes from the data destination 120. The data destination120 stores data elements according to a given format for a given type ofdata structure. For example, in some implementations, data elementscorrespond to values stored in records 122 composed of multiple fields.Each field value (or “property” value) for a given record (e.g., such asa cell in a table for records stored in a table) can have an associatedfield owner, which identifies the data source that determines some typesof changes to the element stored in that field. For example, data fromthe field owner is allowed to be used in changing or deleting theelement stored in that field. Further, each record (e.g., such as a rowin a table for records stored in a table) can have an associated recordowner, which identifies the data source that determines some types ofchanges to the record. For example, the record owner of a record may bethe data source that created the record, and the field owner of a fieldmay be the data source that supplied an initial value for the field. Therecord owner can control the deletion of the record and its associatedfields. In this example, if the record is removed from the data sourceidentified as the record owner, the corresponding record can removedfrom the data destination, or the record owner can otherwise determinewhen it is permissible to delete a record. Similarly, the field ownercan control updates to a value in a field. In some implementations, dataelements correspond to the data stored within versioned data object(e.g., where the data object can correspond to multiple recordsrepresenting different versions of the data object). Once the manager100 has identified which elements in the data destination 120 are to beaccessed for modification, the manager 100 accepts as input the recordowner of each record, and (optionally) the field owner of each element.Because a given record can be associated with a given record owner and aspecific field of the given record can be associated with a given fieldowner, a given element stored in the given field of the given record mayhave one data source specified as record owner and another data sourcespecified as field owner.

Upon accepting the inputs, the manager 100 applies the maintenance plan110 to the data 132 extracted from the data source 130. The maintenanceplan 110 includes the mapping 112, which indicates which elements ofdata arriving from the data source correspond to which elements in thedata destination 120. Once the manager 100 has determined which elementsare to be placed into the data destination 120, the manager 100 appliesthe transformation, validation, and disposition rules to each element.The disposition rules are applied in view of the record and field ownerof each element. Particular rules will determine the course of action ifthe source of an element does not correspond to the record owner orfield owner of that element. For example, if the field owner is not thesame data source as the data source providing a change or update to thefield, a disposition rule may indicate the course of action to take.

During processing, the manager 100 may provide output to the userinterface 140 in the form of status messages, and may accept furtherinput in the event that a user must make a decision as to how to proceedwith a given data element.

Once the manager 100 has applied the rules to the data elements, themanager 100 provides the elements to a loader 104 for the purpose ofplacing them in the data destination 120.

2 Data Storage

Data can come from any of multiple types of sources. Frequently, datacomes from an external source. For example, data might be stored in anexternal database or spreadsheet file. Alternatively, data could beentered manually by a user via a user interface provided by a datastorage system (e.g., a data storage system implementing the datadestination 120). The data maintenance system is capable of maintainingdata that arrives from a wide variety of types of sources, includingthose enumerated here.

The data is likely to change over time. Thus, as part of maintaining anup-to-date data storage system, the system is updated regularly with thelatest version of data in each respective source.

An exemplary data storage system that implements the data destination120 stores collections of data in the form of database tables. FIG. 2shows one representation of a database table. The system stores recordssuch as records 222 a, 222 b, 222 c corresponding to discrete subsets ofdata. Further, the records contain one or more fields 224 a, 224 b, 224c corresponding to different aspects of each subset of data. All of therecords in a collection contained in the storage system may come fromthe same source, or some records may come from one source and otherrecords may come from other sources. Similarly, all of the fields in arecord may come from the same source, or different sources maycontribute different fields to the same record.

As a function of maintaining data derived from multiple data sources,the data maintenance system identifies the data source of each element.The system uses this information to determine whether a particular datasource should be used to change a given element (e.g., changes such asupdating, modifying, or deleting a given element), or to determineinstead if the particular data source would be unsuitable for thispurpose. This may include permitting direct edits of some data throughthe user interface 140, while warning about or preventing user interfaceedits to other data elements that have a data source specified as anowner (e.g., a data source external to the system or a data source thatthe user does not have permissions to override). Further, if a userwishes to modify an externally maintained data element, the system canuse the data source information to route change requests to theappropriate external data source. Some techniques to use this sourceinformation involve maintaining a set of descriptors in the form ofowners.

For example, in some implementations, each field has an associated fieldowner 226 a, 226 b, 226 c, which identifies the data source that isallowed to be used in changing or deleting the element stored in thatfield. In some implementations, the field owner is the data source thatgoverns changes or updates to the element stored in the field. Forexample, the underlying data in the element may have changed, or theremay be additional data supplied for the element besides the data alreadypresent. Further, each record also has an associated record owner 228,which identifies the data source that controls changes to that record.For example, in some implementations the record owner controls whetheror not the record is allowed to be deleted. The owner information can bestored alongside the associated data records in the storage system. Oncethe manager has identified which elements in the data destination are tobe accessed for modification, the manager accepts as input the recordowner and field owner of each element. A given element stored in a givenfield of a given record may be associated with a field owner of thegiven field and a different record owner of the given record. The recordowner and field owner can also be the same data source. An element isalso capable of having an undefined field owner or undefined recordowner.

Some implementations may contain further information about each dataelement. For example, the data maintenance system may also retaininformation about the temporal status of each element. The system couldrecord the time that the element in the data destination was lastmodified by a data source. Similarly, the system could record the timethat the original source element was last modified in the data sourceitself.

3 Data Mapping

For each source that provides data to the data maintenance system, thereis a corresponding mechanism for identifying which data elements in thesource correspond to which data elements in the destination. A datastorage system implementing the data destination stores data in aparticular arrangement, which is usually different than the arrangementthat a given source stores data. Further, as noted above, a complete setof data is frequently derived from multiple data sources. Some datadescribing a given aspect of a dataset may reside in one source, andsome data describing a different aspect of that same dataset may residein a different source. These differing sources may each have their ownmanner of arranging data.

The data manager 100 is capable of mapping each element of data in adata source to a corresponding element in the data destination 120, asseen in FIG. 3. To accomplish this, each data source 330 has anassociated stored mapping 112 as a component of its associatedmaintenance plan. The mapping 112, as well as maintenance plan rules310, are used by an executable portion 300 of the data manager 100. Whensource elements 334 a, 334 b are prepared for inclusion in the datadestination, the stored mapping 112 provides guidance to the manager 100as to where each element should be placed in the data destination.Similarly, if the element is a new version of an older element, themapping 112 provides guidance as to what older element will be removedand replaced by the new version.

Generally, the mapping 112 identifies source records 332, 332 a, 332 bin the data source 330 and the corresponding records 322, 322 a, 322 bin the data destination. Frequently, each element in a source record 332will be placed in the corresponding target record 322 in the datadestination. Alternatively, depending on the arrangement of data in thedata source 330, some of the elements in a source record 332 a will beplaced in one target record 322 a, and some of the other elements in thesource record 332 a will be placed in a different target record 322 b.Further, not all of the elements in a source record 332 need be mappedto a target record 322.

The target record may also contain elements from multiple data sources.Some elements 324 a, 324 b may originate from one source, and at leastone other element 324 c may come from a different source. Generally, thedata destination has a descriptor identifying multiple sources. Therecord owner 328 can indicate the data source that provided the originaldata elements included in the target record when the target record wasfirst created in the data destination. A record may have an undefinedrecord owner. In some implementations, whether or not a data source isconsidered the record owner is controlled by disposition rules. Thefield owners 326 a, 326 b for those original data elements can alsocorrespond to that original data source. If an element 324 c originatedfrom a different source, the corresponding field owner 326 c canindicate that different source. Optionally, the mapping associated withthe different source can indicate that the record itself containing thatelement will not be present in the data destination, but rather thatonly a subset of its elements will be present in the data destination.Further, one or more of the elements 324 a, 324 b, 324 c may uniquelyidentify the record and should be assigned a field owner equal to therecord owner.

The data manager 100 uses the owner information to evaluate whether ornot a given element should be added, removed, or updated by an importingdata source attempting to change the given element (e.g., by comparingthe owner information to the identity of the importing data source).Accordingly, the owner information and identity of the importing datasource are accepted as input by the executable portion 300 in order tomake these evaluations.

4 Data Rules and Processing

Another component of the maintenance plan 110 associated with a datasource 330 is a set of rules 310. These rules alter the data undergoingprocessing to put them in a condition appropriate for loading into thedata destination. As seen in FIG. 4, each rule belongs to the set oftransformation rules 114, validation rules 116, and disposition rules118, depending on the aspect of a data element that the rule affects.The data manager 100 directs incoming data 402 through an executableportion 300, which performs operations sequentially according to eachset of rules. The transformation rule executable portion 404 takes theincoming data 402 as input and provides transformed data as output.Next, the validation rule executable portion 406 takes the transformeddata as input and provides validated data as output, and also providesany error notifications to the user interface 140 if any invalid data isencountered. Finally, the disposition rule executable portion 408 takesthe validated data as input, as well as the mapping 112 associated withthe source of the data, and the record and field owner descriptors 412pertaining to the incoming data elements. Each of the executableportions 404, 406, 408 is optional in that data can be passes alongwithout performing any action if there are no corresponding rules toprocess. Also, the order of the executable portions 404, 406, 408 can bedifferent in other implementations. Depending on the circumstances, thedisposition rule executable portion 408 may provide output to andreceive input from the user interface 140 if a user decision is requiredby one of the disposition rules 118, for example. This executableportion 408 outputs fully processed data 410 for eventual inclusion inthe data destination 120.

Transformation Rules

Besides the aforementioned differences in arranging elements, a givendata source may store an individual element in a particular format,whereas the data destination may store that same element in a differentformat. The data manager 100 can automatically transform this elementfrom the first format to the second while it is undergoing processing.For example, a data source may store text in all uppercase, while thedata destination ideally stores text in all lowercase. The data manager100 applies transformation rules to carry out these automatic changes. Atransformation rule may apply to a particular element from a particularsource, or the rule may apply to any number of elements from any numberof sources.

Validation Rules

The mechanism also determines if a data element is appropriate forinclusion in the data destination. Some data may need to be in a certainformat or within a certain range to be meaningful. For example, a dataelement representing a calendar date must have components correspondingto a month, day, and year, and a month in the range of 1-12 and a day ina range such as 1-31. The data manager 100 applies validation rules toeach element undergoing processing to determine if the element is in avalid form in the context of that element. A validation rule may applyto a particular element from a particular source, or the rule may applyto any number of elements from any number of sources.

Disposition Rules and Source Management

Over time, the composition of a data source may change in a significantfashion. As a matter of course, elements can be expected to change overtime. Further, elements may be added and removed. Each case correspondsto a different course of events in the data source, depending on thecontext. In the event that an element in a data source has simplychanged relative to the element contained in the data storage system,the real-world information associated with the element has likely alsochanged, and so the element has simply been updated accordingly.However, when multiple data sources are making contributions to the sameset of data, this particular data source might represent an olderversion of the data than currently represented in the data destination.

Further, a data element may be missing because the data that the elementconcerns no longer exists, and so the element has been intentionallydeleted. Alternatively, the data element may have been contributed by adifferent data source, or has been moved to a different data source. Or,the data element may still exist in this data source, but under someother identity.

Similarly, the addition of a data element can represent a scenario thatparallels one of the scenarios related to the deletion of an element.The added element may be new information about data, or the element maybe an existing piece of data that now resides at a new location or undera new identity.

The data manager 100 is able to use disposition rules to handle all ofthese types of changes in the composition of a data source. Each rulehandles a particular type of change. A rule can automatically initiate apredefined action, such as removing an element from the data storagesystem. Alternatively, a rule can prompt for further decision-making bya user. In this regard, the disposition rules differentiate scenariosthat can be handed automatically, and scenarios that receive input froma user.

The disposition rules can also handle priority conflicts among multipledata sources. In particular, a disposition rule can rely on the owner ofa given element to determine an appropriate course of action. Whenownership information is being used with a disposition rule, a datasource can only be used to update or delete a particular element in thedata destination if allowed by a disposition rule, according to theownership of the element. For example, in some cases, a data source mustbe defined as an owner of an element if the element is to be used inperforming an update. If the data source is not an owner, the datamanager 100 will apply that element's associated disposition rule totake a proper course of action. The rule may indicate that the elementshould not be updated. Alternatively, the rule may indicate that thisdata source is to be assigned the new owner of the element, and so theupdate may proceed. Another type of rule may indicate that if the fieldowner is undefined, the data source can be used to update the field eventhough the data source is not the field owner.

The disposition rules can also initiate changes in element ownership.For example, if a data source will no longer be used to modify anelement after a certain time, a disposition rule can indicate that theelement's field owner should be set to another data source, or leftundefined for another data source to claim ownership.

A disposition rule may apply to a particular element from a particularsource, or the rule may apply to any number of elements from any numberof sources.

5 Establishing Maintenance Plans

The data storage system has a mechanism for creating a given maintenanceplan associated with a given data source. FIG. 5 shows an example of theportion of the system providing this functionality. A user 542 accessesa user interface 540 to create a plan. This user can be the same as theuser 142 who operates the data manager 100. Similarly, the userinterface 540 can be a component of the user interface 140 used tointeract with the data manager 100.

The user interface 540 is used to define the transformation rules 114,validation rules 116, and disposition rules 118, as well as the mapping112. Together, these comprise the maintenance plan 110, which is placedin persistent storage 150 with existing maintenance plans 110 a, 110 b,110 c. The maintenance plan 110 may optionally be based on one ofseveral maintenance plan templates 510 a, 510 b, 510 c provided to thedata storage system in a template storage 550. These templatescorrespond to common types of data source file formats. Alternatively,the maintenance plan 110 can be created anew in the user interface 540.

6 Exemplary Operation

One possible sequence of operation for the data manager is shown inFIGS. 6A-6C. Referring to FIG. 6A, in step 601, the data source to beprocessed is identified. In step 603, the manager determines if thissource has an existing maintenance plan. If not, in step 605, themanager postpones action until a plan is created. If there is amaintenance plan, in step 607, the manager acquires the plan frompersistent storage. In step 609, the manager identifies an extractor touse to acquire the data in the data source. This extractor could bespecified by the maintenance plan, or by another mechanism. In step 611,the manager accepts the data source from the extractor. In step 613, themanager uses the mapping from the maintenance plan to determine whichrecords in the data source are relevant to which records in the datadestination. In step 615, each relevant record is added or updated inthe data destination, in accordance with the data source and maintenanceplan. Step 615 can take place as multiple iterations, with an iterationcorresponding to a record. In step 617, records in the data destinationare identified for deletion if dictated by the data source andmaintenance plan. This step can also take place in the form of multipleiterations. Next, in step 619, the manager optionally identifies aloader to be used to load the changed data into the data destination,for example, if the changed data was not loaded in step 615 (e.g., ifthe records operated upon were cached copies or temporary copies). Theloader could be specified by the maintenance plan, or by anothermechanism. Finally, in step 621, the added, updated, and deleted recordsare updated in the data destination.

FIG. 6B details example iteration 615 a of step 615, the process ofadding or updating a record in the data destination. In step 631, themanager checks the data source for a record, using the mapping todetermine if the data source has records that may correspond to recordsin the data destination. In step 633, the manager applies the validationand transformation rules to the contents of the record. In step 635, themanager determines if the data destination has a record that correspondsto this source record, based on the mapping in the maintenance plan. Ifthe destination does not have a corresponding record, in step 637, themanager creates a new record, in some cases, with this data source setas record owner. In some cases, the record owner will be undefined, or adifferent data source will be set as record owner. The mapping mayindicate that the record should already exist, but with a differentsource as record owner, and so the manager has the option of leaving thedifferent source as record owner. In step 639, the manager creates thefirst field of the record based on the first field in the data sourcerecord, with the data source set as field owner. In step 641, themanager checks for the next field in the source record, if any. In step643, the manager determines that there is no corresponding field in thedata destination, since this is a newly-created destination record. Thesequence of operation returns to step 639, until all fields have beencreated for this record. The manager may also create placeholder fieldsif the mapping indicates the fields should exist, but the data has notyet been acquired by the manager.

If, in step 635, the manager determined there was a corresponding recordin the data destination, the manager identifies a field in the sourcerecord for processing, in step 641. In step 643, the manager determinesif there is a corresponding field in the destination record. If therenot a corresponding field, the manager follows a similar procedure as ifthe record were new, creating a new field with this data source as thefield owner, and containing the contents of the source field. If themanager determines in step 643 that there is a corresponding field inthe data destination, the manager retrieves the pertinent record ownerand field owner, in step 645. In step 647, the manager checks to see ifthis data source is the field owner, or if the field owner is currentlyundefined. If so, in step 649, the manager replaces the contents of thefield with the data from the source, and returns to step 641. However,if the data source is not the field owner, some implementations of themanager check to see if the data source is the record owner, in step651. If so, the manager updates the field owner to this data source, instep 653. In this situation, the record owner has presumably taken overownership of this field and is updating it with its own dataaccordingly. The data source may also be claiming ownership of a recordwith an undefined record owner. The manager then replaces the fieldcontents in step 649. However, if this data source was neither therecord owner nor the field owner, the manager applies the dispositionrules to determine what further action to take, in step 655. Further, insome implementations, the manager does not use the record owner toupdate the contents of a field. In these implementations, if the datasource is not the field owner, the manager applies the disposition rulesin step 655, skipping step 651. The application of the disposition rulesmay require any number of other sub-steps, including querying a user fora decision through the user interface. To handle priority conflictsbetween multiple data sources, the disposition rules may also be used tocompare relative priority between the existing field owner and thecurrent data source when updating a field. In step 657, the managertakes the appropriate action in accordance with the disposition rules.If the rules allow this data source to modify the field, the managerupdates the field owner in step 653, and replaces the field contents instep 649. Depending on the particular disposition rules defined for thisdata source, or the configuration of the manager, some implementationsmay forgo changing the field owner, or alternatively, also update therecord owner. If the disposition rules do not allow this data source tomodify the field, the manager takes no action in updating the field, instep 659, and returns to step 641. Step 659 may optionally include anerror message or error log entry.

FIG. 6C details example iteration 617 a of step 617, the process ofdeleting a record or field in the data destination. In step 671, themanager checks the data destination for a record, using the mapping todetermine if the data destination has records or fields corresponding torecords or fields potentially missing from the data source. In step 673,the manager determines if a given record that exists in the datadestination also exists in the data source. If not, in step 675, themanager checks the record owner. If this data source is the recordowner, the record is slated for deletion in the data destination, instep 677. This may indicate, for example, that the record existed in thedata source but was recently deleted, and so the data destination shouldbe updated accordingly. If this data source is not the record owner, therecord is not deleted, in step 679. This may indicate, for example, thatthe record still exists in another data source that is this record'sowner.

If, in step 673, the manager determined that the record in the datadestination had a corresponding record in the data source, the manageridentifies and accesses a field in the destination record, in step 681.In step 683, the manager determines if there is a corresponding field inthe data source. If so, the manager defers action on the destinationfield, in step 685. If the manager determines that there is no sourcefield that corresponds to the destination field, however, the managerchecks the field owner, in step 687. If this data source is designatedas the field owner of the destination element, yet the field is absentfrom the data source, then the manager removes this data source as thefield owner, in step 689. With no field owner set, the system can laterremove the contents of this field, or another data source can laterclaim ownership of the field and update the field contents. If this datasource is not the field owner, the manager defers action on the field,in step 685.

7 Exemplary Implementation

The data maintenance approach described above can be implemented usingsoftware for execution on a computer. For instance, the software formsprocedures in one or more computer programs that execute on one or moreprogrammed or programmable computer systems (which may be of variousarchitectures such as distributed, client/server, or grid) eachincluding at least one processor, at least one data storage system(including volatile and non-volatile memory and/or storage elements), atleast one input device or port, and at least one output device or port.The software may form one or more modules of a larger program, forexample, that provides other services related to the design andconfiguration of computation graphs. The nodes and elements of the graphcan be implemented as data structures stored in a computer readablemedium or other organized data conforming to a data model stored in adata repository.

The software may be provided on a storage medium, such as a CD-ROM,readable by a general or special purpose programmable computer ordelivered (encoded in a propagated signal) over a communication mediumof a network to the computer where it is executed. All of the functionsmay be performed on a special purpose computer, or using special-purposehardware, such as coprocessors. The software may be implemented in adistributed manner in which different parts of the computation specifiedby the software are performed by different computers. Each such computerprogram is preferably stored on or downloaded to a storage media ordevice (e.g., solid state memory or media, or magnetic or optical media)readable by a general or special purpose programmable computer, forconfiguring and operating the computer when the storage media or deviceis read by the computer system to perform the procedures describedherein. The inventive system may also be considered to be implemented asa computer-readable storage medium, configured with a computer program,where the storage medium so configured causes a computer system tooperate in a specific and predefined manner to perform the functionsdescribed herein.

A number of embodiments of the invention have been described.Nevertheless, it will be understood that various modifications may bemade without departing from the spirit and scope of the invention. Forexample, some of the steps described above may be order independent, andthus can be performed in an order different from that described.

It is to be understood that the foregoing description is intended toillustrate and not to limit the scope of the invention, which is definedby the scope of the appended claims. For example, a number of thefunction steps described above may be performed in a different orderwithout substantially affecting overall processing. Other embodimentsare within the scope of the following claims.

What is claimed is:
 1. A method for maintaining data in a datamanagement system including at least one processor and a storage system,the method including: accessing a storage system storing a table, thetable including one or more records, each record including at least onefield that contains data, and storing two or more descriptors, at leastsome of the descriptors each comprising data identifying a data sourcefor a record and at least some of the descriptors each comprising dataidentifying a data source for each of one or more fields of the record;and determining if, according to the descriptors and based at least inpart on an identity of a first data source providing one or more sourceelements of data, at least one field in one of the records of the tableis allowed to be changed in response to receiving the source elements ofdata from the first data source; at least one descriptor identifying arecord owner that governs changes to a particular record of the table,and at least one other descriptor identifying a field owner differentfrom the record owner, the field owner governing changes to a dataelement stored in a particular field of the particular record of thetable.
 2. The method of claim 1 including determining if, according toat least one descriptor, any of the source elements is to be used toreplace an element in the storage system.
 3. The method of claim 1including determining if, according to at least one descriptor, anelement in the storage system is to be deleted in response to acorresponding source element being deleted.
 4. The method of claim 1including accessing a second data source providing one or more sourceelements of data different from the source elements provided by thefirst data source.
 5. The method of claim 4 wherein the first datasource is the data source for the record and the second data source isthe data source for at least one of the fields of the record.
 6. Themethod of claim 4 wherein the one or more source elements of the firstdata source and the one or more source elements of the second datasource are each mapped to one or more destination data elements, andwherein the field is determined to be allowed to be changed based on themapping.
 7. The method of claim 6 wherein the one or more destinationdata elements each correspond to one or more fields in the records, andthe mapping corresponds to the data identifying a data source of the oneor more descriptors.
 8. The method of claim 1 wherein at least one ofthe descriptors identifies a data source for a record and at least oneother descriptor identifies another data source for a field of therecord.
 9. The method of claim 1 wherein determining requires userinput.
 10. The method of claim 1 wherein the first data source includesa user interface accepting direct user input.
 11. The method of claim 1wherein a descriptor identifies a record owner that controls changes toa given record.
 12. The method of claim 11 wherein the record ownercontrols deletion of the given record.
 13. The method of claim 11wherein the record owner created the given record.
 14. The method ofclaim 1 wherein a descriptor identifies a field owner that controlschanges to a data element stored in a given field of a given record. 15.The method of claim 14 wherein the field owner controls updates to thedata element stored in the given field.
 16. The method of claim 1including providing a user interface to a user and accepting decisionsfrom the user that relate to the storage system data elements.
 17. Themethod of claim 1 including transforming the element in the storagesystem from a first format to a second format.
 18. The method of claim 1wherein determining if the field can be changed comprises determining ifdata in the field in the storage system is in a valid form in thecontext of that field.
 19. The method of claim 1 including changing thecomposition of the element received from the first data source.
 20. Themethod of claim 1 wherein determining if the field is allowed to bechanged is based on processing one or more rules.
 21. The method ofclaim 20 wherein at least one of the rules is handled automatically,without user input.
 22. The method of claim 20, including accessing amaintenance plan containing the rules.
 23. The method of claim 22wherein the maintenance plan includes a mapping indicating which sourceelements correspond to which elements in the storage system.
 24. Themethod of claim 1 including determining that the identified field owneris different from the identified record owner.
 25. A system formaintaining data, the system including: a storage system including atleast one computer readable storage device, the storage system storing atable, the table including one or more records, each record including atleast one field that contains data, and two or more descriptors, atleast some of the descriptors each comprising data identifying a datasource for a record and at least some of the descriptors each comprisingdata identifying a data source for each of one or more fields of therecord; and a processor configured to execute a data manager, the datamanager configured to determine if, according to the descriptors andbased at least on part on an identity of a first data source providingone or more source elements of data, at least one field in one of therecords of the table is allowed to be changed in response to receivingthe source elements of data from the first data source; at least onedescriptor identifying a record owner that governs changes to aparticular record of the table, and at least one other descriptoridentifying a field owner different from the record owner, the fieldowner governing changes to a data element stored in a particular fieldof the particular record of the table.
 26. The system of claim 25wherein the data manager is configured to determine if, according to atleast one descriptor, any of the source elements is to be used toreplace an element in the storage system.
 27. The system of claim 25wherein the data manager is configured to determine if, according to atleast one descriptor, an element in the storage system is to be deletedin response to a corresponding source element being deleted.
 28. Thesystem of claim 25 including a second data source providing one or moresource elements of data different from the source elements provided bythe first data source.
 29. The system of claim 28 wherein the first datasource is the data source for the record and the second data source isthe data source for at least one of the fields of the record.
 30. Thesystem of claim 28 wherein the one or more source elements of the firstdata source and the one or more source elements of the second datasource are each mapped to one or more destination data elements, and thedata manager is configured to determine if the field is allowed to bechanged based on the mapping.
 31. The system of claim 30 wherein the oneor more destination data elements each correspond to one or more fieldsin the records, and the mapping corresponds to the data identifying adata source of the one or more descriptors.
 32. The system of claim 25wherein at least one of the descriptors identifies a data source for arecord and at least one other descriptor identifies another data sourcefor a field of the record.
 33. The system of claim 25 wherein the datamanager requires user input to determine if one of the fields can bechanged.
 34. The system of claim 25 wherein the first data sourceincludes a user interface accepting direct user input.
 35. The system ofclaim 25 wherein a descriptor identifies a record owner that controlschanges to a given record.
 36. The system of claim 35 wherein the recordowner controls deletion of the given record.
 37. The system of claim 35wherein the record owner created the given record.
 38. The system ofclaim 25 wherein a descriptor identifies a field owner that controlschanges to a data element stored in a given field of a given record. 39.The system of claim 38 wherein the field owner controls updates to thedata element stored in the given field.
 40. The system of claim 25including a user interface providing to the manager decisions of a userthat relate to the storage system data elements.
 41. The system of claim25 wherein the data manager transforms the element in the storage systemfrom a first format to a second format.
 42. The system of claim 25wherein the data manager determines if the element in the storage systemis in a valid form in the context of that element.
 43. The system ofclaim 25 wherein the data manager handles changes in the composition ofthe data source of the element in the storage system.
 44. The system ofclaim 25 wherein the data manager is configured to determine if thefield is allowed to be changed based on processing one or more rules.45. The system of claim 44 wherein at least one of the rules is handledautomatically, without user input.
 46. The system of claim 44 whereinthe data manager operates according to a maintenance plan containing therules.
 47. The system of claim 46 wherein the maintenance plan includesa mapping indicating which source elements correspond to which elementsin the storage system.
 48. The system of claim 25 wherein the datamanager is configured to determine that the identified field owner isdifferent from the identified record owner.
 49. A system for maintainingdata in a data management system, the system including a processor and amemory, the system including: means for accessing a storage systemstoring a table, the table including one or more records, each recordincluding at least one field that contains data, and storing two or moredescriptors, at least some of the descriptors each comprising dataidentifying a data source for a record and at least some of thedescriptors each comprising data identifying a data source for each ofone or more fields of the record; and means for determining if,according to the descriptors and based at least in part on an identityof a first data source providing one or more source elements of data, atleast one field in one of the records of the table is allowed to bechanged in response to receiving the source elements of data from thefirst data source; at least one descriptor identifying a record ownerthat governs changes to a particular record of the table, and at leastone other descriptor identifying a field owner different from the recordowner, the field owner governing changes to a data element stored in aparticular field of the particular record of the table.
 50. Acomputer-readable storage device storing a computer program formaintaining data in a data management system, the computer programincluding instructions for causing a computer to: access a storagesystem storing a table, the table including one or more records, eachrecord including at least one field that contains data, and storing twoor more descriptors, at least some of the descriptors each comprisingdata identifying a data source for a record and at least some of thedescriptors each comprising data identifying a data source for each ofone or more fields of the record; and determine if, according to thedescriptors and based at least on part on an identity of a first datasource providing one or more source elements of data, at least one fieldin one of the records of the table is allowed to be changed in responseto receiving the source elements of data from the first data source; atleast one descriptor identifying a record owner that governs changes toa particular record of the table, and at least one other descriptoridentifying a field owner that governs changes to a data element storedin a particular field of the particular record of the table; anddetermine that the identified field owner is different from theidentified record owner.
 51. The computer-readable storage device ofclaim 50, the operations including determining if, according to at leastone descriptor, any of the source elements is to be used to replace anelement in the storage system.
 52. The computer-readable storage deviceof claim 50, the operations including determining if, according to atleast one descriptor, an element in the storage system is to be deletedin response to a corresponding source element being deleted.
 53. Thecomputer-readable storage device of claim 50, the operations includingaccessing a second data source providing one or more source elements ofdata different from the source elements provided by the first datasource.
 54. The computer-readable storage device of claim 53 wherein theone or more source elements of the first data source and the one or moresource elements of the second data source are each mapped to one or moredestination data elements, and wherein the field is determined to beallowed to be changed based on the mapping.
 55. The computer-readablestorage device of claim 54 wherein the one or more destination dataelements each correspond to one or more fields in the records, and themapping corresponds to the data identifying a data source of the one ormore descriptors.
 56. The computer-readable storage device of claim 53wherein the first data source is the data source for the record and thesecond data source is the data source for at least one of the fields ofthe record.
 57. The computer-readable storage device of claim 50 whereinat least one of the descriptors identifies a data source for a recordand at least one other descriptor identifies another data source for afield of the record.
 58. The computer-readable storage device of claim50 wherein determining requires user input.
 59. The computer-readablestorage device of claim 58 wherein the maintenance plan includes amapping indicating which source elements correspond to which elements inthe storage system.
 60. The computer-readable storage device of claim 50wherein the first data source includes a user interface accepting directuser input.
 61. The computer-readable storage device of claim 50 whereina descriptor identifies a record owner that controls changes to a givenrecord.
 62. The computer-readable storage device of claim 61 wherein therecord owner controls deletion of the given record.
 63. Thecomputer-readable storage device of claim 61 wherein the record ownercreated the given record.
 64. The computer-readable storage device ofclaim 50 wherein a descriptor identifies a field owner that controlschanges to a data element stored in a given field of a given record. 65.The computer-readable storage device of claim 64 wherein the field ownercontrols updates to the data element stored in the given field.
 66. Thecomputer-readable storage device of claim 50, the operations includingproviding a user interface to a user and accepting decisions from theuser that relate to the storage system data elements.
 67. Thecomputer-readable storage device of claim 50, the operations includingtransforming the element in the storage system from a first format to asecond format.
 68. The computer-readable storage device of claim 50wherein determining if the field can be changed comprises determining ifdata in the field in the storage system is in a valid form in thecontext of that field.
 69. The computer-readable storage device of claim50, the operations including changing the composition of the elementreceived from the first data source.
 70. The computer-readable storagedevice of claim 50 wherein determining if the field is allowed to bechanged is based on processing one or more rules.
 71. Thecomputer-readable storage device of claim 70 wherein at least one of therules is handled automatically, without user input.
 72. Thecomputer-readable storage device of claim 70, the operations includingaccessing a maintenance plan containing the rules.